﻿CREATE TABLE [dbo].[Subject] (
    [Id]        INT          IDENTITY (1, 1) NOT NULL,
    [StudentId] INT          NOT NULL,
    [Name]      VARCHAR (20) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Subject_ToStudent] FOREIGN KEY ([StudentId]) REFERENCES [dbo].[Student] ([Id])
);

